<html>
<body>
<?php
echo sqlite_libversion();
echo "<br>";
echo phpversion();

$string = 'People"s Park Complex';
$pattern = '/\"/';
$replacement = "&#34;";
echo preg_replace($pattern, $replacement, $string);


/*
			$dbhandle = sqlite_open('data/winningDB.dat', 0666, $error);
			if (!$dbhandle) 
				die($error);
			
			$query = " CREATE TABLE OUTLET(outlet_id integer PRIMARY KEY, " . 
					 " location text, address text, telephone text, outlet_seq integer) ";
			$status = sqlite_exec($dbhandle, $query, $error);
			if (!$status) 
				die("Cannot execute statement. $error");
			
			sqlite_close($dbhandle);
*/

/*
			$dbhandle = sqlite_open('data/winningDB.dat', 0666, $error);
			if (!$dbhandle) 
				die($error);
			
			$query = " INSERT INTO ANNOUNCEMENT(" . 
					 " announcement_desc, announcement_seq) VALUES ( " .
					 " 'TESTING2', '3' ) ";
			$status = sqlite_exec($dbhandle, $query, $error);
			if (!$status) 
				die("Cannot execute statement. $error");
			
			sqlite_close($dbhandle);
*/


/*

$dbhandle = sqlite_open('data/winningMKTG.testing', 0666, $error);
if (!$dbhandle) die ($error);

$stm = "CREATE TABLE Friends(Id integer PRIMARY KEY," . 
       "Name text UNIQUE NOT NULL, Sex text CHECK(Sex IN ('M', 'F')))";
$ok = sqlite_exec($dbhandle, $stm, $error);

if (!$ok)
   die("Cannot execute query. $error");

echo "Database Friends created successfully";

sqlite_close($dbhandle);
*/




?>
</body>
</html>